<?PHP
$db = sqlite_open('ex3.db', 0666, $sqliteerror);
$query = sqlite_array_query($db, "SELECT * FROM tbl", SQLITE_ASSOC);
 
//Object-oriented style
//$dbhandle = new SQLiteDatabase('ex3.db');
//$query = $dbhandle->arrayQuery('SELECT * FROM tbl', SQLITE_ASSOC);
 
foreach ($query as $entry) {
echo Title: ' . $entry['title'] . ' Length: ' . $entry['length'];
echo "<br>";
}
 
?>
